package com.lijin.study.java.merdeal;

public class UphisRptMchntInfo {

	private String mchntCd;
	private String mchntNm;
	private String supMchntCd;
	private String supMchntNm;
	private String mchntTp;
	
	public String getMchntCd() {
		return mchntCd;
	}
	public void setMchntCd(String mchntCd) {
		this.mchntCd = mchntCd;
	}
	public String getMchntNm() {
		return mchntNm;
	}
	public void setMchntNm(String mchntNm) {
		this.mchntNm = mchntNm;
	}
	public String getSupMchntCd() {
		return supMchntCd;
	}
	public void setSupMchntCd(String supMchntCd) {
		this.supMchntCd = supMchntCd;
	}
	public String getSupMchntNm() {
		return supMchntNm;
	}
	public void setSupMchntNm(String supMchntNm) {
		this.supMchntNm = supMchntNm;
	}
	public String getMchntTp() {
		return mchntTp;
	}
	public void setMchntTp(String mchntTp) {
		this.mchntTp = mchntTp;
	}
	public String toInsertSQL() {
		StringBuilder sql = new StringBuilder("insert into TBL_UPHIS_RPT_MCHNT_INFO (SEQ_ID,MCHNT_CD,MCHNT_NM,SUPE_MCHNT_CD,SUPE_MCHNT_NM,MCHNT_TP,REC_UPD_TS,REC_CRT_TS,COMMENTS) values (NEXTVAL FOR SEQ_UPHIS_RPT_MCHNT_INFO");
		sql.append(",'" + mchntCd + "'");
		sql.append(",'" + mchntNm + "'");
		sql.append(",'" + supMchntCd + "'");
		sql.append(",'" + supMchntNm + "'");
		sql.append(",'" + mchntTp + "'");
		sql.append(", current timestamp, current timestamp,'批量导入');");
		return sql.toString();
	}
}
